CREATE TABLE [dbo].[client]
(
[id_client] [int] NOT NULL IDENTITY(1, 1),
[code] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[client] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[web] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[banque] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[devise] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[adresse_fa] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paysfa] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[villefa] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cpfa] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[adresse_liv] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paysliv] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[villeliv] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cpliv] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[prixminute] [int] NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[client] ADD 
CONSTRAINT [PK_client] PRIMARY KEY CLUSTERED  ([id_client]) ON [PRIMARY]
GO
